Education and Services Hub

Course Title:

Course ID:

150424 0601 1395ESH

Course Dates :

15/Apr/2024

 To

19/Apr/2024

Course Duration :

5

Course Location:

London

United Kingdom

Course Fees GBP £ :

Primary Price

£4,555.99

VAT may vary depending on the country where the course or workshop is held

Course Fees USD $:

Advisory Price

$5,829.09

VAT may vary depending on the country where the course or workshop is held

Course Category:

Computer Science Programmes

MS Excel, Soft Skills

Course Certified By:

* Professional Training and CPD Programs
* Executive Diploma Certificate
* Executive Masters Certificate

* ESHub CPD
* LondonUni
* Others

United Kingdom

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Course Information

Introduction

Welcome to the MS Excel Advanced Course!
This comprehensive training program is designed to equip participants with advanced skills and techniques to maximize their efficiency and productivity using Microsoft Excel.
Whether you're a business professional, analyst, accountant, or student, this course will take your Excel proficiency to the next level.
This MS Excel Advanced Course offers a comprehensive exploration of advanced Excel features, empowering participants to become proficient in data analysis, visualization, automation, and more. Join us for an immersive learning experience that will enhance your Excel skills and boost your professional capabilities.

Objectives

• Enhance your understanding of advanced Excel functions and formulas.
• Master data analysis and visualization techniques.
• Learn how to automate tasks and streamline workflows using macros and VBA.
• Develop proficiency in handling large datasets and performing complex calculations.
• Gain insights into advanced data validation and protection methods.
• Acquire tips and tricks for improving efficiency and accuracy in Excel tasks.

Who Should Attend?

This course is ideal for professionals who already have a basic understanding of Excel and want to deepen their knowledge and skills. It's suitable for:
• Business analysts
• Financial professionals
• Data analysts
• Project managers
• Accountants
• Students and educators
• Anyone seeking to enhance their Excel proficiency

Training Method

• Pre-assessment
• Live group instruction
• Use of real-world examples, case studies and exercises
• Interactive participation and discussion
• Power point presentation, LCD and flip chart
• Group activities and tests
• Each participant receives a 7” Tablet containing a copy of the presentation, slides and handouts
• Post-assessment

Program Support

This program is supported by:
* Interactive discussions
* Role-play
* Case studies and highlight the techniques available to the participants.

Daily Agenda

The course agenda will be as follows:
• Technical Session 08.30-10.00 am
• Coffee Break 10.00-10.15 am
• Technical Session 10.15-12.15 noon
• Coffee Break 12.15-12.45 pm
• Technical Session 12.45-02.30 pm
• Course Ends 02.30 pm

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Week 1

Day 1:
Advanced Functions and Formulas
• Review of basic functions and formulas
• Working with array formulas
• Using logical functions (IF, AND, OR)
• Advanced lookup functions (INDEX, MATCH)
• Date and time functions
• Text functions for data manipulation

Day 2:
Data Analysis and Visualization
• Sorting and filtering data
• Advanced data validation techniques
• Conditional formatting for data visualization
• Creating and customizing PivotTables
• Using PivotCharts for dynamic data analysis
• Introduction to Power Query for data transformation

Day 3:
Automation with Macros
• Introduction to Excel macros
• Recording and editing macros
• Using Visual Basic for Applications (VBA)
• Writing and debugging VBA code
• Automating repetitive tasks
• Creating custom functions with VBA

Day 4:
Advanced Data Management
• Working with large datasets
• Data consolidation and summarization
• Advanced charting techniques
• Statistical analysis with Excel
• What-if analysis and scenario manager
• Data validation and protection

Day 5:
Advanced Techniques and Tips
• Advanced data modeling with Excel
• Collaborative editing and sharing
• Advanced formatting and customization
• Optimizing Excel performance
• Tips and tricks for productivity
• Q&A and wrap-up

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.